CREATE PROCEDURE [dbo].[sp_cat_DeleteManufacturer]
@PKManufacturer varchar(50)
AS
BEGIN
  BEGIN TRAN A
  DELETE FROM CT_Manufacturer WHERE PKManufacturer = @PKManufacturer;
  IF @@ERROR<>0 BEGIN
    ROLLBACK TRAN A
  END
  COMMIT TRAN A
END